package brain;

//import java.sql.Connection;
//import java.sql.ResultSet;
//import java.sql.Statement;

/**
 * 
 * @author JRVamplew
 *
 */
public class Runner {

	//private static Connection connect1 = Connect.StartConnection();
	//private static Statement stmt;
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {

		//ResultSet rs = null;
		//Connection newConnect = connect1;
		
		//Count number of columns in table
		//String SQL = "SELECT COUNT(*) FROM information_schema.columns WHERE table_name = 'words'";
		
        /*try {
			stmt = newConnect.createStatement();
	        rs = stmt.executeQuery(SQL);
	        
	        int columnNumber = 0;
	        while (rs.next()) {
	            columnNumber = new Integer(rs.getString(1));
	            System.out.println("columnNumber: " + columnNumber);
	        }
	        //Get all data from knowledge table
	        SQL = "SELECT * FROM knowledge";
	        rs = stmt.executeQuery(SQL);
	        
	        while (rs.next()) {
	            for(int i=1;i<columnNumber+1;i++) {
	            	System.out.print(rs.getString(i));
	            	System.out.print(" ");
	            }
	            System.out.println();
	        }
	        
	        
        } catch (Exception e) {
        	e.printStackTrace();
        }*/
        
        String[][] tempArray = new String[3][2];
        tempArray[0][0] = "name";
        tempArray[1][0] = "age";
        tempArray[2][0] = "job";
        
        tempArray[0][1] = "John";
        tempArray[1][1] = "25";
        tempArray[2][1] = "Accountant";
        
        
        //QueryBuilder.createNewTable("people", "personID");
        //QueryBuilder.createNewColumn("people", "name", "varchar(100)");
        //QueryBuilder.createNewColumn("people", "age", "varchar(100)");
        //QueryBuilder.createNewColumn("people", "job", "varchar(100)");
        //QueryBuilder.createNewRecord("people", tempArray);
        
        String searchWord = "circle";
        QueryBuilder.getWord(searchWord);
        //QueryBuilder.getWordData(searchWord);
        
    	//String phraseText = "hello";
        //QueryBuilder.getPhrase(phraseText);
        
        //int popLimit = 100;
        //QueryBuilder.initialiseCommonWords(popLimit);
        
	}

}
